[dbo].[BAEEventGetGuestBadgeList]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventGetGuestBadgeList

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@eventCode	varchar(15)	15

SQL Script

CREATE procedure [dbo].[BAEEventGetGuestBadgeList] @eventCode varchar(15) = '' as
SELECT *
    FROM Product p
    INNER JOIN Product_Function pf ON pf.PRODUCT_CODE = p.PRODUCT_CODE
    WHERE PRODUCT_MAJOR = @eventCode AND pf.IS_GUEST_FUNCTION = 1 AND pf.WEB_ENABLED = '1'
    ORDER BY TITLE ASC;

GO

Uses

[dbo].[Product]
[dbo].[Product_Function]
dbo